Filters

Where

When

What

Interactive table

Interactive map

Filters

You can:

• select one or more local authorities from the dropdown menu (remove them with your backspace key)
• select one or more Ofsted grades using the checkboxes
• select the phase of education with the checkboxes
• drag the slider to select a pupil count
• drag the slider to filter by the percenatge of pupils receiving free school meals

Interactive map

You can:

• click to grab and drag the map around
• zoom with the ‘+’ and ‘–’ buttons (top-left) or with your mouse’s scroll wheel
• click a marker to reveal a popup with information about that school
• click the button showing a broken square (top-left under the zoom options) to select points on the map using a window that’s draggable (click and hold the grid icon in the upper left) and resizeable (click and drag the white boxes in each corner)

Interactive table

You can:

• filter each column by typing in the boxes under each column header
• sort the columns (ascending and descending) by clicking on the column header
• change which columns are visible by clicking the Column visibility button
• click ‘CSV’ or ‘Excel’ to download the filtered data to a .csv file or a .xlsx
• see how many entries remain after filtering in the bottom-left, where it says ‘Showing X to Y of Z entries’

Under construction

This tool is under construction. Functionality is missing. The data are just a sample of the original dataset. This will be the case while the tool is in development.

Tools

R v3.5.1 and RStudio v1.1.463 were used.

Packages used were

• Flexdashboard to create a frame for the content
• Leaflet for the interactive map
• DT for the interactive table
• Crosstalk for widget interactivity
• TODO: add more

The code for this tool is available from github.com/matt-dray/scot-deer-collision.